SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbTareas
AS
SELECT     dbo.tb_Tareas.idTarea AS ID, dbo.tb_Procesos.Nombre AS Descripcion, dbo.tb_Tareas.Proceso, dbo.tb_Tareas.Devolucion
FROM         dbo.tb_Procesos INNER JOIN
                      dbo.tb_Tareas ON dbo.tb_Procesos.idProceso = dbo.tb_Tareas.Proceso AND dbo.tb_Procesos.idProceso = dbo.tb_Tareas.SubProceso
GO
GRANT SELECT ON  [dbo].[vwbTareas] TO [SoloVer]
GO
